/* ---------------------------------------------------------------------- */
/* Script generated with: DeZign for Databases v6.3.4                     */
/* Target DBMS:           MS SQL Server 2005                              */
/* Project file:          Project1.dez                                    */
/* Project name:                                                          */
/* Author:                                                                */
/* Script type:           Database drop script                            */
/* Created on:            2012-01-06 16:11                                */
/* ---------------------------------------------------------------------- */


/* ---------------------------------------------------------------------- */
/* Drop foreign key constraints                                           */
/* ---------------------------------------------------------------------- */

ALTER TABLE [Employee] DROP CONSTRAINT [Roll_Employee]
GO


ALTER TABLE [Sys_Roll_Menu] DROP CONSTRAINT [Roll_Sys_Roll_Menu]
GO


ALTER TABLE [Sys_Roll_Menu] DROP CONSTRAINT [menu_Sys_Roll_Menu]
GO


ALTER TABLE [Car_Thue] DROP CONSTRAINT [Car_Car_Thue]
GO


ALTER TABLE [Car_Thue] DROP CONSTRAINT [Employee_Car_Thue]
GO


ALTER TABLE [Lich_driver] DROP CONSTRAINT [Employee_Lich_driver]
GO


ALTER TABLE [Lich_driver] DROP CONSTRAINT [Car_Thue_Lich_driver]
GO


ALTER TABLE [Chi_Tieu] DROP CONSTRAINT [Car_Chi_Tieu]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Lich_driver"                                               */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Lich_driver] DROP CONSTRAINT [PK_Lich_driver]
GO


/* Drop table */

DROP TABLE [Lich_driver]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Car_Thue"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Car_Thue] DROP CONSTRAINT [PK_Car_Thue]
GO


/* Drop table */

DROP TABLE [Car_Thue]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Employee"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Employee] DROP CONSTRAINT [PK_Employee]
GO


/* Drop table */

DROP TABLE [Employee]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Mail"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Mail] DROP CONSTRAINT [PK_Mail]
GO


/* Drop table */

DROP TABLE [Mail]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Chi_Tieu"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Chi_Tieu] DROP CONSTRAINT [PK_Chi_Tieu]
GO


/* Drop table */

DROP TABLE [Chi_Tieu]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Car"                                                       */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Car] DROP CONSTRAINT [PK_Car]
GO


/* Drop table */

DROP TABLE [Car]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Sys_Roll_Menu"                                             */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

/* Drop table */

DROP TABLE [Sys_Roll_Menu]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "menu"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [menu] DROP CONSTRAINT [PK_menu]
GO


/* Drop table */

DROP TABLE [menu]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Roll"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Roll] DROP CONSTRAINT [PK_Roll]
GO


/* Drop table */

DROP TABLE [Roll]
GO

